CREATE TABLE [dbo].[DnnProduct_SearchWord]
(
[SearchWordsID] [int] NOT NULL IDENTITY(1, 1),
[Word] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsCommon] [bit] NULL,
[HitCount] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_SearchWord] ADD CONSTRAINT [PK_DnnProduct_SearchWord] PRIMARY KEY CLUSTERED  ([SearchWordsID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_SearchWord] ADD CONSTRAINT [IX_DnnProduct_SearchWord] UNIQUE NONCLUSTERED  ([Word]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
